package com.smi.dao.vo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RmaDTOExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RmaDTOExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdIsNull() {
            addCriterion("order_item_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdIsNotNull() {
            addCriterion("order_item_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdEqualTo(Integer value) {
            addCriterion("order_item_id =", value, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdNotEqualTo(Integer value) {
            addCriterion("order_item_id <>", value, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdGreaterThan(Integer value) {
            addCriterion("order_item_id >", value, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_item_id >=", value, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdLessThan(Integer value) {
            addCriterion("order_item_id <", value, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdLessThanOrEqualTo(Integer value) {
            addCriterion("order_item_id <=", value, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdIn(List<Integer> values) {
            addCriterion("order_item_id in", values, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdNotIn(List<Integer> values) {
            addCriterion("order_item_id not in", values, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdBetween(Integer value1, Integer value2) {
            addCriterion("order_item_id between", value1, value2, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andOrderItemIdNotBetween(Integer value1, Integer value2) {
            addCriterion("order_item_id not between", value1, value2, "orderItemId");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(Integer value) {
            addCriterion("quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(Integer value) {
            addCriterion("quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(Integer value) {
            addCriterion("quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(Integer value) {
            addCriterion("quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<Integer> values) {
            addCriterion("quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<Integer> values) {
            addCriterion("quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(Integer value1, Integer value2) {
            addCriterion("quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Short value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Short value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Short value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Short value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Short value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Short> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Short> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Short value1, Short value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Short value1, Short value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNull() {
            addCriterion("created_time is null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNotNull() {
            addCriterion("created_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeEqualTo(Date value) {
            addCriterion("created_time =", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotEqualTo(Date value) {
            addCriterion("created_time <>", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThan(Date value) {
            addCriterion("created_time >", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("created_time >=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThan(Date value) {
            addCriterion("created_time <", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("created_time <=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIn(List<Date> values) {
            addCriterion("created_time in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotIn(List<Date> values) {
            addCriterion("created_time not in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeBetween(Date value1, Date value2) {
            addCriterion("created_time between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("created_time not between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeIsNull() {
            addCriterion("updated_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeIsNotNull() {
            addCriterion("updated_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeEqualTo(Date value) {
            addCriterion("updated_time =", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeNotEqualTo(Date value) {
            addCriterion("updated_time <>", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeGreaterThan(Date value) {
            addCriterion("updated_time >", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updated_time >=", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeLessThan(Date value) {
            addCriterion("updated_time <", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("updated_time <=", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeIn(List<Date> values) {
            addCriterion("updated_time in", values, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeNotIn(List<Date> values) {
            addCriterion("updated_time not in", values, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeBetween(Date value1, Date value2) {
            addCriterion("updated_time between", value1, value2, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("updated_time not between", value1, value2, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeIsNull() {
            addCriterion("complete_time is null");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeIsNotNull() {
            addCriterion("complete_time is not null");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeEqualTo(Date value) {
            addCriterion("complete_time =", value, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeNotEqualTo(Date value) {
            addCriterion("complete_time <>", value, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeGreaterThan(Date value) {
            addCriterion("complete_time >", value, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("complete_time >=", value, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeLessThan(Date value) {
            addCriterion("complete_time <", value, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeLessThanOrEqualTo(Date value) {
            addCriterion("complete_time <=", value, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeIn(List<Date> values) {
            addCriterion("complete_time in", values, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeNotIn(List<Date> values) {
            addCriterion("complete_time not in", values, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeBetween(Date value1, Date value2) {
            addCriterion("complete_time between", value1, value2, "completeTime");
            return (Criteria) this;
        }

        public Criteria andCompleteTimeNotBetween(Date value1, Date value2) {
            addCriterion("complete_time not between", value1, value2, "completeTime");
            return (Criteria) this;
        }

        public Criteria andRmaNumberIsNull() {
            addCriterion("rma_number is null");
            return (Criteria) this;
        }

        public Criteria andRmaNumberIsNotNull() {
            addCriterion("rma_number is not null");
            return (Criteria) this;
        }

        public Criteria andRmaNumberEqualTo(String value) {
            addCriterion("rma_number =", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberNotEqualTo(String value) {
            addCriterion("rma_number <>", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberGreaterThan(String value) {
            addCriterion("rma_number >", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberGreaterThanOrEqualTo(String value) {
            addCriterion("rma_number >=", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberLessThan(String value) {
            addCriterion("rma_number <", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberLessThanOrEqualTo(String value) {
            addCriterion("rma_number <=", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberLike(String value) {
            addCriterion("rma_number like", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberNotLike(String value) {
            addCriterion("rma_number not like", value, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberIn(List<String> values) {
            addCriterion("rma_number in", values, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberNotIn(List<String> values) {
            addCriterion("rma_number not in", values, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberBetween(String value1, String value2) {
            addCriterion("rma_number between", value1, value2, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andRmaNumberNotBetween(String value1, String value2) {
            addCriterion("rma_number not between", value1, value2, "rmaNumber");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Short value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Short value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Short value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Short value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Short value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Short> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Short> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Short value1, Short value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Short value1, Short value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andReasonIsNull() {
            addCriterion("reason is null");
            return (Criteria) this;
        }

        public Criteria andReasonIsNotNull() {
            addCriterion("reason is not null");
            return (Criteria) this;
        }

        public Criteria andReasonEqualTo(String value) {
            addCriterion("reason =", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotEqualTo(String value) {
            addCriterion("reason <>", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThan(String value) {
            addCriterion("reason >", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThanOrEqualTo(String value) {
            addCriterion("reason >=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThan(String value) {
            addCriterion("reason <", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThanOrEqualTo(String value) {
            addCriterion("reason <=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLike(String value) {
            addCriterion("reason like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotLike(String value) {
            addCriterion("reason not like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonIn(List<String> values) {
            addCriterion("reason in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotIn(List<String> values) {
            addCriterion("reason not in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonBetween(String value1, String value2) {
            addCriterion("reason between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotBetween(String value1, String value2) {
            addCriterion("reason not between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdIsNull() {
            addCriterion("return_logistics_company_id is null");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdIsNotNull() {
            addCriterion("return_logistics_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdEqualTo(Integer value) {
            addCriterion("return_logistics_company_id =", value, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdNotEqualTo(Integer value) {
            addCriterion("return_logistics_company_id <>", value, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdGreaterThan(Integer value) {
            addCriterion("return_logistics_company_id >", value, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("return_logistics_company_id >=", value, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdLessThan(Integer value) {
            addCriterion("return_logistics_company_id <", value, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdLessThanOrEqualTo(Integer value) {
            addCriterion("return_logistics_company_id <=", value, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdIn(List<Integer> values) {
            addCriterion("return_logistics_company_id in", values, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdNotIn(List<Integer> values) {
            addCriterion("return_logistics_company_id not in", values, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdBetween(Integer value1, Integer value2) {
            addCriterion("return_logistics_company_id between", value1, value2, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCompanyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("return_logistics_company_id not between", value1, value2, "returnLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeIsNull() {
            addCriterion("return_logistics_code is null");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeIsNotNull() {
            addCriterion("return_logistics_code is not null");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeEqualTo(String value) {
            addCriterion("return_logistics_code =", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeNotEqualTo(String value) {
            addCriterion("return_logistics_code <>", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeGreaterThan(String value) {
            addCriterion("return_logistics_code >", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("return_logistics_code >=", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeLessThan(String value) {
            addCriterion("return_logistics_code <", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeLessThanOrEqualTo(String value) {
            addCriterion("return_logistics_code <=", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeLike(String value) {
            addCriterion("return_logistics_code like", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeNotLike(String value) {
            addCriterion("return_logistics_code not like", value, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeIn(List<String> values) {
            addCriterion("return_logistics_code in", values, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeNotIn(List<String> values) {
            addCriterion("return_logistics_code not in", values, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeBetween(String value1, String value2) {
            addCriterion("return_logistics_code between", value1, value2, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andReturnLogisticsCodeNotBetween(String value1, String value2) {
            addCriterion("return_logistics_code not between", value1, value2, "returnLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorIsNull() {
            addCriterion("is_return_to_vendor is null");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorIsNotNull() {
            addCriterion("is_return_to_vendor is not null");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorEqualTo(Short value) {
            addCriterion("is_return_to_vendor =", value, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorNotEqualTo(Short value) {
            addCriterion("is_return_to_vendor <>", value, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorGreaterThan(Short value) {
            addCriterion("is_return_to_vendor >", value, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorGreaterThanOrEqualTo(Short value) {
            addCriterion("is_return_to_vendor >=", value, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorLessThan(Short value) {
            addCriterion("is_return_to_vendor <", value, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorLessThanOrEqualTo(Short value) {
            addCriterion("is_return_to_vendor <=", value, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorIn(List<Short> values) {
            addCriterion("is_return_to_vendor in", values, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorNotIn(List<Short> values) {
            addCriterion("is_return_to_vendor not in", values, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorBetween(Short value1, Short value2) {
            addCriterion("is_return_to_vendor between", value1, value2, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andIsReturnToVendorNotBetween(Short value1, Short value2) {
            addCriterion("is_return_to_vendor not between", value1, value2, "isReturnToVendor");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdIsNull() {
            addCriterion("deliver_logistics_company_id is null");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdIsNotNull() {
            addCriterion("deliver_logistics_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdEqualTo(Integer value) {
            addCriterion("deliver_logistics_company_id =", value, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdNotEqualTo(Integer value) {
            addCriterion("deliver_logistics_company_id <>", value, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdGreaterThan(Integer value) {
            addCriterion("deliver_logistics_company_id >", value, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("deliver_logistics_company_id >=", value, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdLessThan(Integer value) {
            addCriterion("deliver_logistics_company_id <", value, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdLessThanOrEqualTo(Integer value) {
            addCriterion("deliver_logistics_company_id <=", value, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdIn(List<Integer> values) {
            addCriterion("deliver_logistics_company_id in", values, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdNotIn(List<Integer> values) {
            addCriterion("deliver_logistics_company_id not in", values, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdBetween(Integer value1, Integer value2) {
            addCriterion("deliver_logistics_company_id between", value1, value2, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCompanyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("deliver_logistics_company_id not between", value1, value2, "deliverLogisticsCompanyId");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeIsNull() {
            addCriterion("deliver_logistics_code is null");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeIsNotNull() {
            addCriterion("deliver_logistics_code is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeEqualTo(String value) {
            addCriterion("deliver_logistics_code =", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeNotEqualTo(String value) {
            addCriterion("deliver_logistics_code <>", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeGreaterThan(String value) {
            addCriterion("deliver_logistics_code >", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("deliver_logistics_code >=", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeLessThan(String value) {
            addCriterion("deliver_logistics_code <", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeLessThanOrEqualTo(String value) {
            addCriterion("deliver_logistics_code <=", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeLike(String value) {
            addCriterion("deliver_logistics_code like", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeNotLike(String value) {
            addCriterion("deliver_logistics_code not like", value, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeIn(List<String> values) {
            addCriterion("deliver_logistics_code in", values, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeNotIn(List<String> values) {
            addCriterion("deliver_logistics_code not in", values, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeBetween(String value1, String value2) {
            addCriterion("deliver_logistics_code between", value1, value2, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andDeliverLogisticsCodeNotBetween(String value1, String value2) {
            addCriterion("deliver_logistics_code not between", value1, value2, "deliverLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedIsNull() {
            addCriterion("is_all_refunded is null");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedIsNotNull() {
            addCriterion("is_all_refunded is not null");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedEqualTo(Short value) {
            addCriterion("is_all_refunded =", value, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedNotEqualTo(Short value) {
            addCriterion("is_all_refunded <>", value, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedGreaterThan(Short value) {
            addCriterion("is_all_refunded >", value, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedGreaterThanOrEqualTo(Short value) {
            addCriterion("is_all_refunded >=", value, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedLessThan(Short value) {
            addCriterion("is_all_refunded <", value, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedLessThanOrEqualTo(Short value) {
            addCriterion("is_all_refunded <=", value, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedIn(List<Short> values) {
            addCriterion("is_all_refunded in", values, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedNotIn(List<Short> values) {
            addCriterion("is_all_refunded not in", values, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedBetween(Short value1, Short value2) {
            addCriterion("is_all_refunded between", value1, value2, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andIsAllRefundedNotBetween(Short value1, Short value2) {
            addCriterion("is_all_refunded not between", value1, value2, "isAllRefunded");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountIsNull() {
            addCriterion("refunded_amount is null");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountIsNotNull() {
            addCriterion("refunded_amount is not null");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountEqualTo(BigDecimal value) {
            addCriterion("refunded_amount =", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountNotEqualTo(BigDecimal value) {
            addCriterion("refunded_amount <>", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountGreaterThan(BigDecimal value) {
            addCriterion("refunded_amount >", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("refunded_amount >=", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountLessThan(BigDecimal value) {
            addCriterion("refunded_amount <", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("refunded_amount <=", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountIn(List<BigDecimal> values) {
            addCriterion("refunded_amount in", values, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountNotIn(List<BigDecimal> values) {
            addCriterion("refunded_amount not in", values, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refunded_amount between", value1, value2, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refunded_amount not between", value1, value2, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountIsNull() {
            addCriterion("deduct_amount is null");
            return (Criteria) this;
        }

        public Criteria andDeductAmountIsNotNull() {
            addCriterion("deduct_amount is not null");
            return (Criteria) this;
        }

        public Criteria andDeductAmountEqualTo(BigDecimal value) {
            addCriterion("deduct_amount =", value, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountNotEqualTo(BigDecimal value) {
            addCriterion("deduct_amount <>", value, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountGreaterThan(BigDecimal value) {
            addCriterion("deduct_amount >", value, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("deduct_amount >=", value, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountLessThan(BigDecimal value) {
            addCriterion("deduct_amount <", value, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("deduct_amount <=", value, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountIn(List<BigDecimal> values) {
            addCriterion("deduct_amount in", values, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountNotIn(List<BigDecimal> values) {
            addCriterion("deduct_amount not in", values, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deduct_amount between", value1, value2, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deduct_amount not between", value1, value2, "deductAmount");
            return (Criteria) this;
        }

        public Criteria andDeductReasonIsNull() {
            addCriterion("deduct_reason is null");
            return (Criteria) this;
        }

        public Criteria andDeductReasonIsNotNull() {
            addCriterion("deduct_reason is not null");
            return (Criteria) this;
        }

        public Criteria andDeductReasonEqualTo(String value) {
            addCriterion("deduct_reason =", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonNotEqualTo(String value) {
            addCriterion("deduct_reason <>", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonGreaterThan(String value) {
            addCriterion("deduct_reason >", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonGreaterThanOrEqualTo(String value) {
            addCriterion("deduct_reason >=", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonLessThan(String value) {
            addCriterion("deduct_reason <", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonLessThanOrEqualTo(String value) {
            addCriterion("deduct_reason <=", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonLike(String value) {
            addCriterion("deduct_reason like", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonNotLike(String value) {
            addCriterion("deduct_reason not like", value, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonIn(List<String> values) {
            addCriterion("deduct_reason in", values, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonNotIn(List<String> values) {
            addCriterion("deduct_reason not in", values, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonBetween(String value1, String value2) {
            addCriterion("deduct_reason between", value1, value2, "deductReason");
            return (Criteria) this;
        }

        public Criteria andDeductReasonNotBetween(String value1, String value2) {
            addCriterion("deduct_reason not between", value1, value2, "deductReason");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdIsNull() {
            addCriterion("return_address_id is null");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdIsNotNull() {
            addCriterion("return_address_id is not null");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdEqualTo(Integer value) {
            addCriterion("return_address_id =", value, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdNotEqualTo(Integer value) {
            addCriterion("return_address_id <>", value, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdGreaterThan(Integer value) {
            addCriterion("return_address_id >", value, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("return_address_id >=", value, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdLessThan(Integer value) {
            addCriterion("return_address_id <", value, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdLessThanOrEqualTo(Integer value) {
            addCriterion("return_address_id <=", value, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdIn(List<Integer> values) {
            addCriterion("return_address_id in", values, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdNotIn(List<Integer> values) {
            addCriterion("return_address_id not in", values, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdBetween(Integer value1, Integer value2) {
            addCriterion("return_address_id between", value1, value2, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andReturnAddressIdNotBetween(Integer value1, Integer value2) {
            addCriterion("return_address_id not between", value1, value2, "returnAddressId");
            return (Criteria) this;
        }

        public Criteria andVendorIdIsNull() {
            addCriterion("vendor_id is null");
            return (Criteria) this;
        }

        public Criteria andVendorIdIsNotNull() {
            addCriterion("vendor_id is not null");
            return (Criteria) this;
        }

        public Criteria andVendorIdEqualTo(Integer value) {
            addCriterion("vendor_id =", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdNotEqualTo(Integer value) {
            addCriterion("vendor_id <>", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdGreaterThan(Integer value) {
            addCriterion("vendor_id >", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("vendor_id >=", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdLessThan(Integer value) {
            addCriterion("vendor_id <", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdLessThanOrEqualTo(Integer value) {
            addCriterion("vendor_id <=", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdIn(List<Integer> values) {
            addCriterion("vendor_id in", values, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdNotIn(List<Integer> values) {
            addCriterion("vendor_id not in", values, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdBetween(Integer value1, Integer value2) {
            addCriterion("vendor_id between", value1, value2, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdNotBetween(Integer value1, Integer value2) {
            addCriterion("vendor_id not between", value1, value2, "vendorId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNull() {
            addCriterion("supplier_id is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNotNull() {
            addCriterion("supplier_id is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdEqualTo(Integer value) {
            addCriterion("supplier_id =", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotEqualTo(Integer value) {
            addCriterion("supplier_id <>", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThan(Integer value) {
            addCriterion("supplier_id >", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("supplier_id >=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThan(Integer value) {
            addCriterion("supplier_id <", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThanOrEqualTo(Integer value) {
            addCriterion("supplier_id <=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIn(List<Integer> values) {
            addCriterion("supplier_id in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotIn(List<Integer> values) {
            addCriterion("supplier_id not in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdBetween(Integer value1, Integer value2) {
            addCriterion("supplier_id between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotBetween(Integer value1, Integer value2) {
            addCriterion("supplier_id not between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andVendorAuditIsNull() {
            addCriterion("vendor_audit is null");
            return (Criteria) this;
        }

        public Criteria andVendorAuditIsNotNull() {
            addCriterion("vendor_audit is not null");
            return (Criteria) this;
        }

        public Criteria andVendorAuditEqualTo(Short value) {
            addCriterion("vendor_audit =", value, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditNotEqualTo(Short value) {
            addCriterion("vendor_audit <>", value, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditGreaterThan(Short value) {
            addCriterion("vendor_audit >", value, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditGreaterThanOrEqualTo(Short value) {
            addCriterion("vendor_audit >=", value, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditLessThan(Short value) {
            addCriterion("vendor_audit <", value, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditLessThanOrEqualTo(Short value) {
            addCriterion("vendor_audit <=", value, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditIn(List<Short> values) {
            addCriterion("vendor_audit in", values, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditNotIn(List<Short> values) {
            addCriterion("vendor_audit not in", values, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditBetween(Short value1, Short value2) {
            addCriterion("vendor_audit between", value1, value2, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andVendorAuditNotBetween(Short value1, Short value2) {
            addCriterion("vendor_audit not between", value1, value2, "vendorAudit");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeIsNull() {
            addCriterion("return_biz_type is null");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeIsNotNull() {
            addCriterion("return_biz_type is not null");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeEqualTo(Short value) {
            addCriterion("return_biz_type =", value, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeNotEqualTo(Short value) {
            addCriterion("return_biz_type <>", value, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeGreaterThan(Short value) {
            addCriterion("return_biz_type >", value, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("return_biz_type >=", value, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeLessThan(Short value) {
            addCriterion("return_biz_type <", value, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeLessThanOrEqualTo(Short value) {
            addCriterion("return_biz_type <=", value, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeIn(List<Short> values) {
            addCriterion("return_biz_type in", values, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeNotIn(List<Short> values) {
            addCriterion("return_biz_type not in", values, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeBetween(Short value1, Short value2) {
            addCriterion("return_biz_type between", value1, value2, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizTypeNotBetween(Short value1, Short value2) {
            addCriterion("return_biz_type not between", value1, value2, "returnBizType");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdIsNull() {
            addCriterion("return_biz_id is null");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdIsNotNull() {
            addCriterion("return_biz_id is not null");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdEqualTo(String value) {
            addCriterion("return_biz_id =", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdNotEqualTo(String value) {
            addCriterion("return_biz_id <>", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdGreaterThan(String value) {
            addCriterion("return_biz_id >", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdGreaterThanOrEqualTo(String value) {
            addCriterion("return_biz_id >=", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdLessThan(String value) {
            addCriterion("return_biz_id <", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdLessThanOrEqualTo(String value) {
            addCriterion("return_biz_id <=", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdLike(String value) {
            addCriterion("return_biz_id like", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdNotLike(String value) {
            addCriterion("return_biz_id not like", value, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdIn(List<String> values) {
            addCriterion("return_biz_id in", values, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdNotIn(List<String> values) {
            addCriterion("return_biz_id not in", values, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdBetween(String value1, String value2) {
            addCriterion("return_biz_id between", value1, value2, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andReturnBizIdNotBetween(String value1, String value2) {
            addCriterion("return_biz_id not between", value1, value2, "returnBizId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Long value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Long value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Long value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Long value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Long value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Long> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Long> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Long value1, Long value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Long value1, Long value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}